Tabela LServRes

Definicja tabeli LServRes

Name

LServRes

Code

LServRes

Comment

 


Lista kolumn tabeli LServRes

Name

Code

ServID

ServID

ResourceID

ResourceID

UnitID

UnitID

UnitsCount

UnitsCount

PerNoOfUnits

PerNoOfUnits

Mandatory

Mandatory

StartDT

StartDT

StopDT

StopDT


Kolumna ServID tabeli LServRes

Definicja kolumny ServID tabeli LServRes

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ResourceID tabeli LServRes

Definicja kolumny ResourceID tabeli LServRes

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna UnitID tabeli LServRes

Definicja kolumny UnitID tabeli LServRes

Name

UnitID

Code

UnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UnitsCount tabeli LServRes

Definicja kolumny UnitsCount tabeli LServRes

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(12,6)

Mandatory

No

Comment

 


Kolumna PerNoOfUnits tabeli LServRes

Definicja kolumny PerNoOfUnits tabeli LServRes

Name

PerNoOfUnits

Code

PerNoOfUnits

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Mandatory tabeli LServRes

Definicja kolumny Mandatory tabeli LServRes

Name

Mandatory

Code

Mandatory

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna StartDT tabeli LServRes

Definicja kolumny StartDT tabeli LServRes

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LServRes

Definicja kolumny StopDT tabeli LServRes

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Lista kluczy tabeli LServRes

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LServRes

Definicja klucza Identifier_1 tabeli LServRes

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment